__________________________________________________________________________________________________
SELECT Email FROM Person GROUP BY Email
HAVING COUNT(*) > 1;
__________________________________________________________________________________________________
SELECT DISTINCT p1.Email FROM Person p1
JOIN Person p2 ON p1.Email = p2.Email
WHERE p1.Id <> p2.Id;
__________________________________________________________________________________________________
